package com.apexedu.eas.dao.impl;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.apexedu.eas.annotation.Query;
import com.apexedu.eas.entity.test.Message;

@Repository
public class MsgDao {
	
	/**
	 * 查询没有发送过信息的 (status=0)
	 * @return
	 */
	@Query(value="select * from  @Message where zt<>2 and pl<sysdate",replace=true)
	public List<Message> queryNoSend(){
		return null;
	}
	
	/**
	 * 发送信息之后修改状态
	 * @param id
	 * @return
	 */
	@Query(value="update @Message set zt=?,sj=to_date(?,'yyyy-MM-dd hh24:mi:ss') where id=?",update=true,replace=true)
	public Integer updateStatus(Integer zt,String sendTime,Integer id){
		return null;
	}
	
}
